Search TipsUnallocated Usage Analytics
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
| Batch Identifier | Y | Numeric | ID number for the batch job | |
|
Detail Sequence |
|
Numeric |
1,0 |
|
|
Usage Type |
|
Numeric |
1 |
CMP code for the usage type |
|
Usage Type Description |
|
Alphanumeric |
30,0 |
Text description of the usage type |
| Usage Date Time | Numeric | 25,0 | The date and time the usage took place. YYYY-MM-DD HH:MM:SS format | |
| Subscription Number | Numeric | 7,0 | CMP number for the subscription associated with the usage | |
|
Network Serial Number |
|
Numeric |
10,0 |
Serial number of the network associated with the usage |
|
Dialled Number |
|
Alphanumeric |
18 |
Dialled Number |
|
Actual usage units |
Numeric |
|
The actual amount of usage consumed, in units |
|
|
Billable Usage Units |
|
Numeric |
|
The amount of usage consumed, in units, that can be invoiced for |
|
Usage Classification |
|
Alphanumeric |
12,0 |
CMP code for the usage class, for example, DOMDATA |
|
Usage Classification Description |
|
Alphanumeric |
30,0 |
Text description of the Usage Class code, for example, Domestic Data |
|
Wholesale charge |
|
Numeric |
11,4 |
The wholesale charge of the usage, to 4 decimal places. |
|
Retail Charge |
|
Numeric |
11,4 |
The retail price of the usage, to 4 decimal places. |
|
Access Retail Charge |
|
Numeric |
11,4 |
If there is an access charge for the usage, the amount to 4 decimal places |
|
Service Retail Charge |
Numeric |
11,4 |
If there is a charge for the service, the amount to 4 decimal places |
|
| Audit Timestamp | Numeric | 25,0 | The date and time of audit. YYYY-MM-DD HH:MM:SS format | |
| Audit User | Alphanumeric | User name of user who last changed data | ||
| Data Extract Date | Numeric | 7,0 | Date and time this extract was created. YYYY-MM-DD format |